package com.example.skycodes.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class AdminDao {

    DBConnection DBConn = new DBConnection();
    public boolean Checklogin(String s1, String s2) throws SQLException {
        // conn对象 代表了MySql数据库sky5链接
        Connection conn = DBConn.getConn();
        Statement stmt = conn.createStatement();
        ResultSet rs = null;
        boolean OK = true;
        // todo 密码加密 账户密码过滤
        String sql = "select * from admin where" + "AdminName=" + s1 + " and  AdminPwd=" + s2;
        rs = stmt.executeQuery(sql);// 执行sql语句
        if (!rs.next()){
            OK = false;
        }
        return OK;
    }
}
